EMT Practice Test

1. Question Content...

---

Question1: Which of the following can be used to translate data into another form so it can only be read by a user who has a key or a password?

Question2: Given the table below:

Which of the following variable types BEST describes the "Year" column?

Question3: A data analyst has been asked to create an ad-hoc sales report for the Chief Executive Officer (CEO).
Which of the following should be included in the report?

Question4: Which of the following is the correct data type for text?

Question5: The current date is July 14, 2020. A data analyst has been asked to create a report that shows the company's year-over-year Q2 2020 sales. Which of the following reports should the analyst compare?

Question6: Which of the following would be used to store unstructured data from different sources?

Question7: Which of the following will MOST likely be streamed live?

Question8: Which one of the following in NOT a common data integration tool?

Question9: Which of the following data sampling methods involves dividing a population into subgroups by similar characteristics?

Question10: An analyst has received the requirements for an internal user dashboard. The analyst confirms the data sources and then creates a wireframe. Which of the following is the NEXT step the analyst should take in the dashboard creation process?

Question11: What role in a data governance is typically responsible for day-to-day oversight of data use?

Question12: Exhibit.

Which of the following logical statements results in Table B?

Question13: A data analyst for a media company needs to determine the most popular movie genre. Given the table below:

Which of the following must be done to the Genre column before this task can be completed?

Question14: Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?

Question15: A publishing group has requested a dashboard to track submissions before publication. A key requirement is that all changes are tracked, as multiple users will be checking out documents and editing them before submissions are considered final. Which of the following is the BEST way to meet this stakeholder requirement?

Question16: When analyzing the values of two variables, you decide to convert both variables so they are on a scale of 0 to 1.
What term describes this action?

Question17: Daniel is using the structured Query language to work with data stored in relational database.
He would like to add several new rows to a database table.
What command should he use?

Question18: Which of the following differentiates a flat text file from other data types?

Question19: Given the diagram below:

Which of the following types of sampling is depicted in the image?

Question20: You would like to measure how well an organization is achieving its goals.
What type of analysis should you perform?

Question21: The process of performing initial investigations on data to spot outliers, discover patterns, and test assumptions with statistical insight and graphical visualization is called:

Question22: While reviewing survey data, a research analyst notices data is missing from all the responses to a single question. Which of the following methods would BEST address this issue?

Question23: An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000:

Which of the following functions did the analyst use to generate the data in the Sales_indicator column?

Question24: An analyst needs to conduct a quick analysis. Which of the following is the FIRST step the analyst should perform with the data?

Question25: Mario works with a group of R programmers tasked with copying data from an accounting system into a data warehouse.
In what phase are the group's R skills most relevant?

Question26: Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?

Question27: Which of the following value is the measure of dispersion "range" between the scores of ten students in a test.
The scores of ten students in a test are 17, 23, 30, 36, 45, 51, 58, 66, 72, 77.

Question28: Which of the following is a process that is used during data integration to collect, blend, and load data?

Question29: A recurring event is being stored in two databases that are housed in different geographical locations. A data analyst notices the event is being logged three hours earlier in one database than in the other database. Which of the following is the MOST likely cause of the issue?

Question30: The director of operations at a power company needs data to help identify where company resources should be allocated in order to monitor activity for outages and restoration of power in the entire state. Specifically, the director wants to see the following:
* County outages
* Status
* Overall trend of outages
INSTRUCTIONS:
Please, select each visualization to fit the appropriate space on the dashboard and choose an appropriate color scheme. Once you have selected all visualizations, please, select the appropriate titles and labels, if applicable.
Titles and labels may be used more than once.
If at any time you would like to bring back the initial state of the simulation, please click the Reset All button.

Power outages

Question31: Which one of the following values will appear first if they are sorted in descending order?

Question32: Jenny wants to study the academic performance of undergraduate sophomores and wants to determine the average grade point average at different points during an academic year.
What best describes the data set she needs?

Question33: Which of the following BEST describes standard deviation?

Question34: Which of the following is an example of a at flat file?

Question35: A data analyst is asked to create a sales report for the second-quarter 2020 board meeting, which will include a review of the business's performance through the second quarter. The board meeting will be held on July 15,
2020, after the numbers are finalized. Which of the following report types should the data analyst create?

Question36: You are working with a dataset and need to swap the values in rows with those in columns.
What action do you need to perform?

Question37: A data analyst for a media company needs to determine the most popular movie genre. Given the table below:

Which of the following must be done to the Genre column before this task can be completed?

Question38: A data analyst needs to create a data visualization that aids in un the cumulative impact of sequentially introduced values that are positive or negative. Which of the following data visualization methods should the analyst use?

Question39: Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?

Question40: An e-commerce company recently tested a new website layout. The website was tested by a test group of customers, and an old website was presented to a control group. The table below shows the percentage of users in each group who made purchases on the websites:

Which of the following conclusions is accurate at a 95% confidence interval?

Question41: A data analyst needs to create a weekly recurring report on sales performance and distribute it to all sales managers. Which of the following would be the BEST method to automate and ensure successful delivery for this task?

Question42: While reviewing survey data, an analyst notices respondents entered "Jan," "January," and "01" as responses for the month of January. Which of the following steps should be taken to ensure data consistency?

Question43: Randy scored 76 on a math test, Katie scored 86 on a science test, Ralph scored 80 on a history test, and Jean scored 80 on an English test. The table below contains the mean and standard deviation of the scores for each of the courses:

Using this information, which of the following students had the BEST score?

Question44: Which of the following is a control measure for preventing a data breach?

Question45: Jhon is working on an ELT process that sources data from six different source systems.
Looking at the source data, he finds that data about the sample people exists in two of six systems.
What does he have to make sure he checks for in his ELT process?
Choose the best answer.

Question46: Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?

Question47: Amanda needs to create a dashboard that will draw information from many other data sources and present it to business leaders.
Which one of the following tools is least likely to meet her needs?

Question48: Which of the following should be accomplished NEXT after understanding a business requirement for a data analysis report?

Question49: Which of the following contains alphanumeric values?

Question50: A data analyst must separate the column shown below into multiple columns for each component of the name:

Which of the following data manipulation techniques should the analyst perform?

Question51: You should always choose the analytics tool that is most appropriate for any given situation, even if that means acquiring a new tool.

Question52: Joseph is interpreting a left skewed distribution of test scores. Joe scored at the mean, Alfonso scored at the median, and gaby scored and the end of the tail.
Who had the highest score?

Question53: A data analyst wants to create "Income Categories" that would be calculated based on the existing variable
"Income". The "Income Categories" would be as follows:
Income category 1: less than $1.
Income category 2: more than $1 and less than $20,000.
Income category 3: more than $20,001 and less than $40,000.
Income category 4: more than $40,001.
Which of the following data manipulation techniques should the data analyst use to create "Income Categories"?

Question54: The number of phone calls that the call center receives in a day is an example of:

Question55: Which of the ing is the correct ion for a tab-delimited spre file?

Question56: A development company is constructing a new unit in its apartment complex. The complex has the following floor plans:

Using the average cost per square foot of the original floor plans, which of the following should be the price of the Rose unit?

Question57: A user receives a large custom report to track company sales across various date ranges. The user then completes a series of manual calculations for each date range. Which of the following should an analyst suggest so the user has a dynamic, seamless experience?

Question58: A sales team wants visibility of current sales numbers, pipeline, and team performance. The team would also like to see calculations of individuals' earned commissions and projected commissions based on sales, but they want that information to be kept confidential. Which of the following would be the BEST way to provide this visibility?

Question59: A financial institution is reporting on sales performance to a company at the account level. Due to the sensitive nature of the government the does il with, some account information is not shown. Which of the following fields should be masked?

Question60: A data analyst has a set with more than 40.000 rows in the sample schema below:

The analyst would like to create one column that contains the customers' birth dates. Which of the following data quality dimensions would BEST explain the reason for compilation?

Question61: Which one of the following is a common data warehouse schema?

Question62: What category of data stewardship work is focused on ensuring that the organization respects the wishes of data subjects?

Question63: What subset of Structured Query Language (SQL) is used to add, remove, modify, or retrieve the information stored within a relational database?

Question64: An analyst is working with the income data of suburban families in the United States. The data set has a lot of outliers, and the analyst needs to provide a measure that represents the typical income. Which of the following would BEST fulfill the analyst's goal?